package com.neudu.glsb.mapper;

import com.neudu.glsb.pojo.Member;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import io.lettuce.core.dynamic.annotation.Param;

import java.math.BigDecimal;

/**
* @author Lenovo
* @description 针对表【member】的数据库操作Mapper
* @createDate 2025-10-20 10:23:17
* @Entity com.neudu.glsb.pojo.Member
*/
public interface MemberMapper extends BaseMapper<Member> {
    // 充值金额：id改为Integer类型
    int recharge(@Param("id") Integer id, @Param("amount") BigDecimal amount);
//    @Param("amount") BigDecimal amount,

    // 积分兑换：id改为Integer类型
    int exchangePoints(@Param("id") Integer id, @Param("exchangePoints") Integer exchangePoints, @Param("exchangeAmount") BigDecimal exchangeAmount);


    // 退会员（新增）：余额清零 + 积分清零 + 状态改为已注销 + 更新时间
    int cancelMember(@Param("id") Integer id);
}




